﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true"
    CodeBehind="SearchCars.aspx.cs" Inherits="carportal.SearchCars" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <script language="javascript">
        function ShowDiv(id) {
            var state = document.getElementById(id).style.display;
            if (state == 'block') {
                document.getElementById(id).style.display = 'none';
            } else {
                document.getElementById(id).style.display = 'block';
            }
        }
        ShowDiv("detailedsearch");
    </script>
    <style type="text/css">
        .style3
        {
            width: 344px;
        }
        .style4
        {
            width: 177px;
        }
        .style5
        {
            width: 361px;
        }
        .style7
        {
            width: 231px;
        }
        .style8
        {
            width: 102%;
        }
        .style9
        {
            width: 433px;
        }
        .style11
        {
            height: 481px;
            width: 101%;
        }
        .style12
        {
            width: 214px;
        }
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table class="style1 style11">
        <tr>
            <td class="style4" valign="top">
                <div id="searchbox" class="custom_panel1">
                    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                        <ContentTemplate>
                            Make:<br />
                            <asp:DropDownList ID="DropDownListCarMakes" runat="server" DataSourceID="SqlDataSource1"
                                DataTextField="make_name" DataValueField="id" Width="171px" AutoPostBack="True">
                            </asp:DropDownList>
                            <br />
                            Model:<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>"
                                SelectCommand="SELECT id, make_id, model FROM carportal_model WHERE (make_id = @make_id)">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="DropDownListCarMakes" Name="make_id" PropertyName="SelectedValue" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>"
                                SelectCommand="SELECT [id], [make_name] FROM [carportal_make]"></asp:SqlDataSource>
                            <br />
                            <asp:DropDownList ID="DropDownList2" runat="server" Width="163px" DataSourceID="SqlDataSource2"
                                DataTextField="model" DataValueField="id">
                            </asp:DropDownList>
                            <br />
                            <table>
                                <tr>
                                    <td>
                                        Year From:
                                    </td>
                                    <td>
                                        Year to:
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        <asp:DropDownList ID="DropDownList3" runat="server">
                                            <asp:ListItem>2012</asp:ListItem>
                                            <asp:ListItem>2011</asp:ListItem>
                                            <asp:ListItem>2010</asp:ListItem>
                                            <asp:ListItem>2009</asp:ListItem>
                                            <asp:ListItem>2008</asp:ListItem>
                                            <asp:ListItem>2007</asp:ListItem>
                                            <asp:ListItem>2006</asp:ListItem>
                                            <asp:ListItem>2005</asp:ListItem>
                                            <asp:ListItem>2004</asp:ListItem>
                                            <asp:ListItem>2003</asp:ListItem>
                                            <asp:ListItem>2002</asp:ListItem>
                                            <asp:ListItem>2001</asp:ListItem>
                                            <asp:ListItem>2000</asp:ListItem>
                                            <asp:ListItem>1999</asp:ListItem>
                                            <asp:ListItem>1998</asp:ListItem>
                                            <asp:ListItem>1997</asp:ListItem>
                                            <asp:ListItem>1996</asp:ListItem>
                                            <asp:ListItem>1995</asp:ListItem>
                                            <asp:ListItem>1994</asp:ListItem>
                                            <asp:ListItem>1993</asp:ListItem>
                                            <asp:ListItem>1992</asp:ListItem>
                                            <asp:ListItem>1991</asp:ListItem>
                                            <asp:ListItem>1990</asp:ListItem>
                                            <asp:ListItem>1989</asp:ListItem>
                                            <asp:ListItem>1988</asp:ListItem>
                                            <asp:ListItem>1987</asp:ListItem>
                                            <asp:ListItem>1986</asp:ListItem>
                                            <asp:ListItem>1985</asp:ListItem>
                                        </asp:DropDownList>
                                    </td>
                                    <td>
                                        <asp:DropDownList ID="DropDownList4" runat="server">
                                            <asp:ListItem>2012</asp:ListItem>
                                            <asp:ListItem>2011</asp:ListItem>
                                            <asp:ListItem>2010</asp:ListItem>
                                            <asp:ListItem>2009</asp:ListItem>
                                            <asp:ListItem>2008</asp:ListItem>
                                            <asp:ListItem>2007</asp:ListItem>
                                            <asp:ListItem>2006</asp:ListItem>
                                            <asp:ListItem>2005</asp:ListItem>
                                            <asp:ListItem>2004</asp:ListItem>
                                            <asp:ListItem>2003</asp:ListItem>
                                            <asp:ListItem>2002</asp:ListItem>
                                            <asp:ListItem>2001</asp:ListItem>
                                            <asp:ListItem>2000</asp:ListItem>
                                            <asp:ListItem>1999</asp:ListItem>
                                            <asp:ListItem>1998</asp:ListItem>
                                            <asp:ListItem>1997</asp:ListItem>
                                            <asp:ListItem>1996</asp:ListItem>
                                            <asp:ListItem>1995</asp:ListItem>
                                            <asp:ListItem>1994</asp:ListItem>
                                            <asp:ListItem>1993</asp:ListItem>
                                            <asp:ListItem>1992</asp:ListItem>
                                            <asp:ListItem>1991</asp:ListItem>
                                            <asp:ListItem>1990</asp:ListItem>
                                            <asp:ListItem>1989</asp:ListItem>
                                            <asp:ListItem>1988</asp:ListItem>
                                            <asp:ListItem>1987</asp:ListItem>
                                            <asp:ListItem>1986</asp:ListItem>
                                            <asp:ListItem>1985</asp:ListItem>
                                        </asp:DropDownList>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Price from:
                                    </td>
                                    <td>
                                        Price to:
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        <asp:DropDownList ID="DropDownList5" runat="server" Height="20px" Width="79px">
                                            <asp:ListItem>300</asp:ListItem>
                                            <asp:ListItem>400</asp:ListItem>
                                            <asp:ListItem>500</asp:ListItem>
                                            <asp:ListItem>600</asp:ListItem>
                                            <asp:ListItem>700</asp:ListItem>
                                            <asp:ListItem>800</asp:ListItem>
                                            <asp:ListItem>900</asp:ListItem>
                                            <asp:ListItem>1000</asp:ListItem>
                                            <asp:ListItem>1100</asp:ListItem>
                                            <asp:ListItem>1200</asp:ListItem>
                                            <asp:ListItem>1300</asp:ListItem>
                                            <asp:ListItem>1400</asp:ListItem>
                                            <asp:ListItem>1500</asp:ListItem>
                                            <asp:ListItem>1600</asp:ListItem>
                                            <asp:ListItem>1700</asp:ListItem>
                                            <asp:ListItem>1800</asp:ListItem>
                                            <asp:ListItem>1900</asp:ListItem>
                                            <asp:ListItem>2000</asp:ListItem>
                                            <asp:ListItem>2500</asp:ListItem>
                                            <asp:ListItem>3000</asp:ListItem>
                                            <asp:ListItem>3500</asp:ListItem>
                                            <asp:ListItem>4000</asp:ListItem>
                                            <asp:ListItem>4500</asp:ListItem>
                                            <asp:ListItem>5000</asp:ListItem>
                                            <asp:ListItem>5500</asp:ListItem>
                                            <asp:ListItem>6000</asp:ListItem>
                                            <asp:ListItem>6500</asp:ListItem>
                                            <asp:ListItem>7000</asp:ListItem>
                                            <asp:ListItem>7500</asp:ListItem>
                                            <asp:ListItem>8000</asp:ListItem>
                                            <asp:ListItem>8500</asp:ListItem>
                                            <asp:ListItem>9000</asp:ListItem>
                                            <asp:ListItem>9500</asp:ListItem>
                                            <asp:ListItem>10000</asp:ListItem>
                                            <asp:ListItem>10500</asp:ListItem>
                                            <asp:ListItem>11000</asp:ListItem>
                                            <asp:ListItem>11500</asp:ListItem>
                                            <asp:ListItem>12000</asp:ListItem>
                                            <asp:ListItem>12500</asp:ListItem>
                                            <asp:ListItem>13000</asp:ListItem>
                                            <asp:ListItem>13500</asp:ListItem>
                                            <asp:ListItem>14000</asp:ListItem>
                                            <asp:ListItem>14500</asp:ListItem>
                                            <asp:ListItem>15000</asp:ListItem>
                                            <asp:ListItem>15500</asp:ListItem>
                                            <asp:ListItem>16000</asp:ListItem>
                                            <asp:ListItem>16500</asp:ListItem>
                                            <asp:ListItem>17000</asp:ListItem>
                                            <asp:ListItem>17500</asp:ListItem>
                                            <asp:ListItem>18000</asp:ListItem>
                                            <asp:ListItem>18500</asp:ListItem>
                                            <asp:ListItem>19000</asp:ListItem>
                                            <asp:ListItem>19500</asp:ListItem>
                                            <asp:ListItem>20000</asp:ListItem>
                                        </asp:DropDownList>
                                    </td>
                                    <td class="style3">
                                        <asp:DropDownList ID="DropDownList6" runat="server">
                                            <asp:ListItem>300</asp:ListItem>
                                            <asp:ListItem>400</asp:ListItem>
                                            <asp:ListItem>500</asp:ListItem>
                                            <asp:ListItem>600</asp:ListItem>
                                            <asp:ListItem>700</asp:ListItem>
                                            <asp:ListItem>800</asp:ListItem>
                                            <asp:ListItem>900</asp:ListItem>
                                            <asp:ListItem>1000</asp:ListItem>
                                            <asp:ListItem>1100</asp:ListItem>
                                            <asp:ListItem>1200</asp:ListItem>
                                            <asp:ListItem>1300</asp:ListItem>
                                            <asp:ListItem>1400</asp:ListItem>
                                            <asp:ListItem>1500</asp:ListItem>
                                            <asp:ListItem>1600</asp:ListItem>
                                            <asp:ListItem>1700</asp:ListItem>
                                            <asp:ListItem>1800</asp:ListItem>
                                            <asp:ListItem>1900</asp:ListItem>
                                            <asp:ListItem>2000</asp:ListItem>
                                            <asp:ListItem>2500</asp:ListItem>
                                            <asp:ListItem>3000</asp:ListItem>
                                            <asp:ListItem>3500</asp:ListItem>
                                            <asp:ListItem>4000</asp:ListItem>
                                            <asp:ListItem>4500</asp:ListItem>
                                            <asp:ListItem>5000</asp:ListItem>
                                            <asp:ListItem>5500</asp:ListItem>
                                            <asp:ListItem>6000</asp:ListItem>
                                            <asp:ListItem>6500</asp:ListItem>
                                            <asp:ListItem>7000</asp:ListItem>
                                            <asp:ListItem>7500</asp:ListItem>
                                            <asp:ListItem>8000</asp:ListItem>
                                            <asp:ListItem>8500</asp:ListItem>
                                            <asp:ListItem>9000</asp:ListItem>
                                            <asp:ListItem>9500</asp:ListItem>
                                            <asp:ListItem>10000</asp:ListItem>
                                            <asp:ListItem>10500</asp:ListItem>
                                            <asp:ListItem>11000</asp:ListItem>
                                            <asp:ListItem>11500</asp:ListItem>
                                            <asp:ListItem>12000</asp:ListItem>
                                            <asp:ListItem>12500</asp:ListItem>
                                            <asp:ListItem>13000</asp:ListItem>
                                            <asp:ListItem>13500</asp:ListItem>
                                            <asp:ListItem>14000</asp:ListItem>
                                            <asp:ListItem>14500</asp:ListItem>
                                            <asp:ListItem>15000</asp:ListItem>
                                            <asp:ListItem>15500</asp:ListItem>
                                            <asp:ListItem>16000</asp:ListItem>
                                            <asp:ListItem>16500</asp:ListItem>
                                            <asp:ListItem>17000</asp:ListItem>
                                            <asp:ListItem>17500</asp:ListItem>
                                            <asp:ListItem>18000</asp:ListItem>
                                            <asp:ListItem>18500</asp:ListItem>
                                            <asp:ListItem>19000</asp:ListItem>
                                            <asp:ListItem>19500</asp:ListItem>
                                            <asp:ListItem>20000</asp:ListItem>
                                        </asp:DropDownList>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        <asp:Button ID="Button1" runat="server" Text="Search" OnClick="Button1_Click" />
                                        <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>"
                                            SelectCommand="SELECT carportal_cars.id, carportal_cars.user_id, carportal_cars.make, carportal_cars.model, carportal_cars.model_by_user, carportal_cars.car_type, carportal_cars.engine_power, carportal_cars.first_reg_date, carportal_cars.millage_km, carportal_cars.fuel_type, carportal_cars.gearbox, carportal_cars.price, carportal_cars.country_code, carportal_cars.location_city, carportal_cars.climate_control, carportal_cars.seat_count, carportal_cars.color, carportal_cars.door_count, carportal_cars.Auxiliary_heating, carportal_cars.Central_locking, carportal_cars.Cruise_control, carportal_cars.Electric_heated, carportal_cars.Electric_windows, carportal_cars.Leather_seats, carportal_cars.Parking_sensors, carportal_cars.Power_Steering, carportal_cars.Sunroof, carportal_cars.Four_wheel_drive, carportal_cars.Immobilizer, carportal_cars.Xenon_headlights, carportal_cars.ABS, carportal_cars.ESP, carportal_cars.user_comments, carportal_make.make_name, carportal_model.model AS modelname, carportal_countries.countryname, carportal_vehicletypes.vehicletype FROM carportal_cars INNER JOIN carportal_make ON carportal_cars.make = carportal_make.id INNER JOIN carportal_model ON carportal_cars.model = carportal_model.id INNER JOIN carportal_countries ON carportal_cars.country_code = carportal_countries.id INNER JOIN carportal_vehicletypes ON carportal_cars.car_type = carportal_vehicletypes.id  ">
                                            
                                        </asp:SqlDataSource>
                                    </td>
                                    <td class="style3">
                                        <asp:LinkButton ID="LinkButton1" OnClientClick="ShowDiv('detailedsearch');return false;"
                                            runat="server">Detailed Search</asp:LinkButton>
                                    </td>
                                </tr>
                            </table>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </div>
            </td>
            <td valign="top">
                <div id="detailedsearch" class="custom_panel1">
                    <table class="style8">
                        <tr>
                            <td class="style5" valign="top">
                                <asp:CheckBox ID="FCheckBox1" runat="server" Text="Auxiliary heating" meta:resourcekey="FCheckBox1Resource1" /><br />
                                <asp:CheckBox ID="FCheckBox2" runat="server" Text="Central locking" meta:resourcekey="FCheckBox2Resource1" /><br />
                                <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:bestgifts4usConnectionString %>"
                                    SelectCommand="SELECT [id], [countrycode], [countryname] FROM [carportal_countries]">
                                </asp:SqlDataSource>
                                <asp:CheckBox ID="FCheckBox3" runat="server" Text="Cruise control " meta:resourcekey="FCheckBox3Resource1" /><br />
                                <asp:CheckBox ID="FCheckBox4" runat="server" Text="Electric heated seats" meta:resourcekey="FCheckBox4Resource1" /><br />
                                <asp:CheckBox ID="FCheckBox5" runat="server" Text="Electric windows" meta:resourcekey="FCheckBox5Resource1" /><br />
                                <asp:CheckBox ID="FCheckBox6" runat="server" Text="Leather seats" meta:resourcekey="FCheckBox6Resource1" /><br />
                                <asp:CheckBox ID="FCheckBox7" runat="server" Text="Parking sensors " meta:resourcekey="FCheckBox7Resource1" /><br />
                            </td>
                            <td class="style9" colspan="2">
                                <asp:CheckBox ID="FCheckBox8" runat="server" Text="Power Assisted Steering" meta:resourcekey="FCheckBox8Resource1" />
                                <br />
                                <asp:CheckBox ID="FCheckBox9" runat="server" Text="Sunroof" meta:resourcekey="FCheckBox9Resource1" />
                                <br />
                                <asp:CheckBox ID="FCheckBox10" runat="server" Text="Four wheel drive" meta:resourcekey="FCheckBox10Resource1" />
                                <br />
                                <asp:CheckBox ID="FCheckBox11" runat="server" Text="Immobilizer" meta:resourcekey="FCheckBox11Resource1" />
                                <br />
                                <asp:CheckBox ID="FCheckBox13" runat="server" Text="Xenon headlights" meta:resourcekey="FCheckBox13Resource1" />
                                <br />
                                <asp:CheckBox ID="FCheckBox14" runat="server" Text="ABS" meta:resourcekey="FCheckBox14Resource1" />
                                <br />
                                <asp:CheckBox ID="FCheckBox15" runat="server" Text="ESP" meta:resourcekey="FCheckBox15Resource1" />
                            </td>
                            <td class="style7">
                                <br />
                            </td>
                        </tr>
                        <tr>
                            <td class="style5" valign="top">
                                Clima:<br />
                                <asp:DropDownList ID="DropDownListClima" runat="server" meta:resourcekey="DropDownList8Resource1">
                                    <asp:ListItem meta:resourcekey="ListItemResource30" Value="0">No</asp:ListItem>
                                    <asp:ListItem Selected="True" meta:resourcekey="ListItemResource31" Value="1">Automatic</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource32" Value="1">Manual</asp:ListItem>
                                </asp:DropDownList>
                            </td>
                            <td class="style12">
                                Door Count:<br />
                                <asp:DropDownList ID="DropDownListDorrCount" runat="server" meta:resourcekey="DropDownList10Resource1">
                                    <asp:ListItem meta:resourcekey="ListItemResource39">2</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource40">3</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource41">4</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource42">5</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource43">6</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource44">7</asp:ListItem>
                                </asp:DropDownList>
                            </td>
                            <td class="style9">
                                Number of seats:<br />
                                <asp:DropDownList ID="DropDownListSeatcount" runat="server" meta:resourcekey="DropDownList9Resource1">
                                    <asp:ListItem meta:resourcekey="ListItemResource33">2</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource34">4</asp:ListItem>
                                    <asp:ListItem>5</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource35">6</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource36">7</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource37">8</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource38">More</asp:ListItem>
                                </asp:DropDownList>
                            </td>
                            <td class="style7">
                                &nbsp;
                            </td>
                        </tr>
                        <tr>
                            <td class="style5" valign="top">
                                Location:<br />
                                <asp:DropDownList ID="DropDownListCountrycodes" runat="server" DataSourceID="SqlDataSource4"
                                    DataTextField="countryname" DataValueField="id" Width="144px" AppendDataBoundItems="True"
                                    meta:resourcekey="DropDownList7Resource1" OnInit="DropDownListCountrycodes_Init">
                                </asp:DropDownList>
                            </td>
                            <td class="style9" colspan="2">
                                Color:<br />
                                <asp:DropDownList ID="DropDownListColor" runat="server" meta:resourcekey="DropDownList11Resource1">
                                    <asp:ListItem meta:resourcekey="ListItemResource45">Beige</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource46">Black</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource47">Blue</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource48">Brown</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource49">Gold</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource50">Green</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource51">Grey</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource52">Orange</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource53">Purple</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource54">Red</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource55">Silver</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource56">White</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource57">Yellow</asp:ListItem>
                                    <asp:ListItem meta:resourcekey="ListItemResource58">Other</asp:ListItem>
                                </asp:DropDownList>
                                <br />
                            </td>
                            <td class="style7">
                                &nbsp;
                            </td>
                        </tr>
                        <tr>
                            <td class="style5" valign="top">
                                &nbsp;
                            </td>
                            <td class="style9" colspan="2">
                                &nbsp;
                            </td>
                            <td class="style7">
                                &nbsp;
                            </td>
                        </tr>
                        <tr>
                            <td class="style5" valign="top">
                                &nbsp;
                            </td>
                            <td class="style9" colspan="2">
                                &nbsp;
                            </td>
                            <td class="style7">
                                &nbsp;
                            </td>
                        </tr>
                    </table>
                    <br />
                </div>
            </td>
        </tr>
        <tr>
            <td class="style4" valign="top">
                &nbsp;</td>
            <td valign="top">
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style4" valign="top">
                <br />
                <br />
                <br />
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    DataKeyNames="id" DataSourceID="SqlDataSource5">
                    <Columns>
                        <asp:BoundField DataField="make_name" HeaderText="make_name" 
                            SortExpression="make_name" />
                        <asp:BoundField DataField="modelname" HeaderText="modelname" 
                            SortExpression="modelname" />
                        <asp:BoundField DataField="countryname" HeaderText="countryname" 
                            SortExpression="countryname" />
                        <asp:BoundField DataField="model_by_user" HeaderText="model_by_user" 
                            SortExpression="model_by_user" />
                        <asp:BoundField DataField="car_type" HeaderText="car_type" 
                            SortExpression="car_type" />
                        <asp:BoundField DataField="engine_power" HeaderText="engine_power" 
                            SortExpression="engine_power" />
                        <asp:BoundField DataField="first_reg_date" HeaderText="first_reg_date" 
                            SortExpression="first_reg_date" />
                        <asp:BoundField DataField="millage_km" HeaderText="millage_km" 
                            SortExpression="millage_km" />
                        <asp:BoundField DataField="fuel_type" HeaderText="fuel_type" 
                            SortExpression="fuel_type" />
                        <asp:BoundField DataField="gearbox" HeaderText="gearbox" 
                            SortExpression="gearbox" />
                        <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
                        <asp:BoundField DataField="country_code" HeaderText="country_code" 
                            SortExpression="country_code" />
                        <asp:BoundField DataField="location_city" HeaderText="location_city" 
                            SortExpression="location_city" />
                        <asp:BoundField DataField="climate_control" HeaderText="climate_control" 
                            SortExpression="climate_control" />
                        <asp:BoundField DataField="seat_count" HeaderText="seat_count" 
                            SortExpression="seat_count" />
                        <asp:BoundField DataField="color" HeaderText="color" SortExpression="color" />
                        <asp:BoundField DataField="door_count" HeaderText="door_count" 
                            SortExpression="door_count" />
                        <asp:CheckBoxField DataField="Auxiliary_heating" HeaderText="Auxiliary_heating" 
                            SortExpression="Auxiliary_heating" />
                        <asp:CheckBoxField DataField="Central_locking" HeaderText="Central_locking" 
                            SortExpression="Central_locking" />
                        <asp:CheckBoxField DataField="Cruise_control" HeaderText="Cruise_control" 
                            SortExpression="Cruise_control" />
                        <asp:CheckBoxField DataField="Electric_heated" HeaderText="Electric_heated" 
                            SortExpression="Electric_heated" />
                        <asp:CheckBoxField DataField="Electric_windows" HeaderText="Electric_windows" 
                            SortExpression="Electric_windows" />
                        <asp:CheckBoxField DataField="Leather_seats" HeaderText="Leather_seats" 
                            SortExpression="Leather_seats" />
                        <asp:CheckBoxField DataField="Parking_sensors" HeaderText="Parking_sensors" 
                            SortExpression="Parking_sensors" />
                        <asp:CheckBoxField DataField="Power_Steering" HeaderText="Power_Steering" 
                            SortExpression="Power_Steering" />
                        <asp:CheckBoxField DataField="Sunroof" HeaderText="Sunroof" 
                            SortExpression="Sunroof" />
                        <asp:CheckBoxField DataField="Four_wheel_drive" HeaderText="Four_wheel_drive" 
                            SortExpression="Four_wheel_drive" />
                        <asp:CheckBoxField DataField="Immobilizer" HeaderText="Immobilizer" 
                            SortExpression="Immobilizer" />
                        <asp:CheckBoxField DataField="Xenon_headlights" HeaderText="Xenon_headlights" 
                            SortExpression="Xenon_headlights" />
                        <asp:CheckBoxField DataField="ABS" HeaderText="ABS" SortExpression="ABS" />
                        <asp:CheckBoxField DataField="ESP" HeaderText="ESP" SortExpression="ESP" />
                        <asp:BoundField DataField="user_comments" HeaderText="user_comments" 
                            SortExpression="user_comments" />
                        <asp:BoundField DataField="vehicletype" HeaderText="vehicletype" 
                            SortExpression="vehicletype" />
                    </Columns>
                </asp:GridView>
                <br />
                <br />
                <br />
                <br />
                <br />
                <br />
                <br />
            </td>
            <td valign="top">
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>
